asql software package provides Run SQL queries against apache logs, you can install in your Ubuntu 16.04 LTS (Xenial Xerus) by running the commands given below on the terminal,
$ sudo apt-get update $ sudo apt-get install asql
asql is installed in your system.
Make ensure the asql package were installed using the commands given below,
$ sudo dpkg-query -l | grep asql *
You will get with asql package name, version, architecture and description in a table
| Distro | Ubuntu 16 04 lts xenial xerus |
| Section | Administration Utilities |
| Package | asql |
| Version | 1.6-1 |
| Description | Run SQL queries against apache logs |
| Sub Section | admin |